Normalization Completeness for Conceptual Model using Quantitative Fuzzy Functionality

In this new approach to measure normalization completeness for conceptual model is introduced using quantitative fuzzy functionality. We measure the normalization completeness for conceptual model in two steps. In the first step different normalization techniques are analyzed up to Boyee Codd Normal Form (BCNF) to find the current normal form of the relation. In the second step fuzzy membership values are used to scale the normal form between 0 and 1. This research is incorporating case studies to explain the normalization completeness measurement process. Normalization completeness is measured by considering completeness attributes, preventing attributes of the functional dependencies and total number of attributes. If the functional dependency is non-preventing then the attributes of that functional dependency are completeness attributes. The attributes of functional dependency which prevent to go to the next normal form are called preventing attributes.